SET IDENTITY_INSERT [Make] ON 

INSERT INTO MAKE (MakeId,MakeName) VALUES (1,'Acura')
INSERT INTO MAKE (MakeId,MakeName) VALUES (2,'Toyota')
INSERT INTO MAKE (MakeId,MakeName) VALUES (3,'Ford')
INSERT INTO MAKE (MakeId,MakeName) VALUES (4,'Volks Wagen')
INSERT INTO MAKE (MakeId,MakeName) VALUES (5,'Audi')
INSERT INTO MAKE (MakeId,MakeName) VALUES (6,'Aston Martin')
INSERT INTO MAKE (MakeId,MakeName) VALUES (7,'Bentley')
INSERT INTO MAKE (MakeId,MakeName) VALUES (8,'BMW')
INSERT INTO MAKE (MakeId,MakeName) VALUES (9,'Buick')
INSERT INTO MAKE (MakeId,MakeName) VALUES (10,'Cadillac')
INSERT INTO MAKE (MakeId,MakeName) VALUES (11,'Chevrolet')
INSERT INTO MAKE (MakeId,MakeName) VALUES (12,'Chrysler')
INSERT INTO MAKE (MakeId,MakeName) VALUES (13,'Dodge')
INSERT INTO MAKE (MakeId,MakeName) VALUES (14,'Ferrari')
INSERT INTO MAKE (MakeId,MakeName) VALUES (15,'GMC')
INSERT INTO MAKE (MakeId,MakeName) VALUES (16,'Honda')
INSERT INTO MAKE (MakeId,MakeName) VALUES (17,'Hummer')
INSERT INTO MAKE (MakeId,MakeName) VALUES (18,'Hyundai')
INSERT INTO MAKE (MakeId,MakeName) VALUES (19,'Infinity')
INSERT INTO MAKE (MakeId,MakeName) VALUES (20,'Jaguar')
INSERT INTO MAKE (MakeId,MakeName) VALUES (21,'Jeep')
INSERT INTO MAKE (MakeId,MakeName) VALUES (22,'KIA')
INSERT INTO MAKE (MakeId,MakeName) VALUES (23,'Lamborghini')
INSERT INTO MAKE (MakeId,MakeName) VALUES (24,'Land Rover')
INSERT INTO MAKE (MakeId,MakeName) VALUES (25,'Lexus')
INSERT INTO MAKE (MakeId,MakeName) VALUES (26,'Lincoln')
INSERT INTO MAKE (MakeId,MakeName) VALUES (27,'Lotus')
INSERT INTO MAKE (MakeId,MakeName) VALUES (28,'Maserati')
INSERT INTO MAKE (MakeId,MakeName) VALUES (29,'Maybach')
INSERT INTO MAKE (MakeId,MakeName) VALUES (30,'Mazda')
INSERT INTO MAKE (MakeId,MakeName) VALUES (31,'Mercedes-Benz')
INSERT INTO MAKE (MakeId,MakeName) VALUES (32,'Mercury')
INSERT INTO MAKE (MakeId,MakeName) VALUES (33,'MINI')
INSERT INTO MAKE (MakeId,MakeName) VALUES (34,'Mitsubishi')
INSERT INTO MAKE (MakeId,MakeName) VALUES (35,'Nissan')
INSERT INTO MAKE (MakeId,MakeName) VALUES (36,'Pontiac')
INSERT INTO MAKE (MakeId,MakeName) VALUES (37,'Porsche')
INSERT INTO MAKE (MakeId,MakeName) VALUES (38,'Rolls-Royce')
INSERT INTO MAKE (MakeId,MakeName) VALUES (39,'Saab')
INSERT INTO MAKE (MakeId,MakeName) VALUES (40,'Saturn')
INSERT INTO MAKE (MakeId,MakeName) VALUES (41,'Scion')
INSERT INTO MAKE (MakeId,MakeName) VALUES (42,'Smart')
INSERT INTO MAKE (MakeId,MakeName) VALUES (43,'Subaru')
INSERT INTO MAKE (MakeId,MakeName) VALUES (44,'Suzuki')
INSERT INTO MAKE (MakeId,MakeName) VALUES (45,'Volvo')

SET IDENTITY_INSERT [Make] OFF



SET IDENTITY_INSERT [Model] ON 
-- Acura, id:1
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (1,1,'1.7 EL')
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (2,1,'RSX')

-- Toyota, id:2
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (3,2,'Yaris')
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (4,2,'Camry')

-- Ford, id:3
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (5,3,'Taurus')
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (6,3,'Mustang')

-- VW, id:4
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (7,4,'Jetta')
INSERT INTO Model (ModelId,MakeId,ModelName) VALUES (8,4,'Rabbit')


SET IDENTITY_INSERT [Model] OFF

 
